Formula rather than result shown in cell due to formula not begin with =.
Cause:
This problem occurs because the formula does not begin with an equal sign.
Solution:
Add an equal sign (=) at the beginning of the formula.